Dashboard 03 - Creating Matrix, Map, & Line and Stacked Column chart Visualizations - Part 01 20


In this step, we will create a matrix, map and chart in the 3rd dashboard.


Step 1 - Create a Block Address Matrix


In Power BI Desktop, click on the page, RaleighPoliceIncidents-Street


Visualizations

Click the Matrix icon

Fields

Select the following:

A_KeyMeasures ->  .Total_Case_Numbers  - Under Visualizations, drag & drop it in the Values section

A_KeyMeasures ->  .Total_Shooting_Crimes  - Under Visualizations, drag & drop it in the Values section

Raleigh_Police_Incidents_NIBRS ->  Crime_Description - Under Visualizations, drag & drop it in the Rows section

Raleigh_Police_Incidents_NIBRS ->  MonthFull - Under Visualizations, drag & drop it in the Rows section

Raleigh_Police_Incidents_NIBRS ->  Reported_Block_Address - Under Visualizations, drag & drop it in the Rows section

Raleigh_Police_Incidents_NIBRS ->  reported_Date_Hierarchy ->  Reported_Date - Under Visualizations, drag & drop it in the Rows section

Raleigh_Police_Incidents_NIBRS ->  reported_Date_Hierarchy ->  Reported_Year - Under Visualizations, drag & drop it in the Rows section

Raleigh_Police_Incidents_NIBRS ->  reported_dayofwk - Under Visualizations, drag & drop it in the Rows section



Visualizations


Fields tab

Under Fields tab, click on the down arrow ->  Rename for this visual and rename the fields as follows:

.Total_Case_Numbers = Total Police Incidents

.Total_Shooting_Crimes = Total Shootings

Crime_Description = Crime Description

Reported_Block_Address = Reported Block Address

reported_dayofwk = Reported Day of the Week


Visualization Listing should look as follows, in the following order:




Format tab


Under Format ->  General: X Position = 0 , Y Position = 156 , Width = 605 , Height = 496

Under Format -> Grid ->  Outline Color = 094780 , Outline Weight =  1 , Text Size = 12 pt , Image Height = 75

Under Format -> Column Headers ->  Font Color = 094780 , Background Color = E6E6E6 , Outline = Bottom Only , Font Family = 13 pt , Title Alignment = Center

Under Format -> Row Headers ->  Font Color = 000000 , Background Color = FFFFFF , Stepped Layout = ON ,  Font Family = 12 pt , Icon Size = 12 pt

Under Format ->  Subtotals -> Set it to ON ->  Font Color = 000000 , Font Family = Segoe UI , Background Color = FFFFFF , Text Size = 13 pt , Row Subtotal Position = Top

Under Format ->  Grand Total -> Set it to ON ->  Font Color = 000000 , Font Family = Segoe UI , Background Color = FFFFFF , Text Size = 13 pt

Under Format ->  Conditional Formatting ->  Background Color = OFF , Font Color = ON , Advanced Controls , Format by = Rules , Apply to = Values Only , Based on Field = .Total_Case_Numbers , Rules:

If Value is greater than or equal to 0 Number and is less then 50 Number then Color = 008000

If Value is greater than or equal to 51 Number and is less then 100 Number then Color = A0D1FF

If Value is greater than or equal to 101 Number and is less then 250 Number then Color = E68F96

If Value is greater than or equal to 251 Number and is less then 500 Number then Color = DE6A73

If Value is greater than or equal to 501 Number and is less then 999999 Number then Color = FF0000




Under Format -> Title ->  Set it to OFF

Under Format ->  Background ->  Set it to ON , Color = FFF

Under Format ->  Border ->  Set it to ON , Color = 666666



Filters

None




When finished, save project.



How to Create matrix visualizations in Power BI